Problem Note 45375: Using the DBSASTYPE data set option on a z/OS system might result in an error
Accessing a DBMS table with a query that includes the data set option DBSASTYPE= causes implicit pass-through to be turned off. This is currently by design. Including any data set options in the query is one of the documented reasons that causes implicit pass-through to be disabled. If you have turned on tracing with the SASTRACE= system option, the following notes appear in your SAS log:
SAS_SQL: Cannot handle dataset options.
SAS_SQL: Unable to convert the query to a DBMS specific SQL statement due
to an error.
ACCESS ENGINE: SQL statement was not passed to the DBMS, SAS will do the
processing.
One of the following errors might also appear in your SAS log if you are accessing a DB2 table on z/OS:
ERROR: DB2 prepare error: DSNT408I SQLCODE = -401, ERROR: THE OPERANDS
OF AN ARITHMETIC OR COMPARISON OPERATION ARE NOT COMPARABLE.
ERROR: (ACCDB2M041E) The column T1_ID does not exist.
There is currently no workaround for this problem.
Click the Hot Fix tab in this note to access the hot fix for this issue.
Operating System and Release Information
SAS System | SAS/ACCESS Interface to DB2 | z/OS | 9.2 TS1M0 | 9.3 TS1M2 |
*
For software releases that are not yet generally available, the Fixed
Release is the software release in which the problem is planned to be
fixed.
Type: | Problem Note |
Priority: | high |
Date Modified: | 2012-09-11 09:53:35 |
Date Created: | 2012-01-12 10:34:38 |